Overview
Brought to you by YData
Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 7051560 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 140696 |
| Duplicate rows (%) | 2.0% |
| Total size in memory | 813.7 MiB |
| Average record size in memory | 121.0 B |
Variable types
| Categorical | 3 |
|---|---|
| Numeric | 7 |
| Text | 3 |
| Boolean | 9 |
| Dataset has 140696 (2.0%) duplicate rows | Duplicates |
Severity is highly imbalanced (56.3%) | Imbalance |
Amenity is highly imbalanced (90.3%) | Imbalance |
Give_Way is highly imbalanced (95.7%) | Imbalance |
Junction is highly imbalanced (62.3%) | Imbalance |
No_Exit is highly imbalanced (97.4%) | Imbalance |
Railway is highly imbalanced (92.9%) | Imbalance |
Stop is highly imbalanced (81.7%) | Imbalance |
Traffic_Calming is highly imbalanced (98.9%) | Imbalance |
Duration_Seconds is highly skewed (γ1 = 50.61168934) | Skewed |
Distance(mi) has 2959002 (42.0%) zeros | Zeros |
Wind_Speed(mph) has 942813 (13.4%) zeros | Zeros |
Reproduction
| Analysis started | 2024-11-04 23:33:25.030150 |
|---|---|
| Analysis finished | 2024-11-04 23:36:35.560166 |
| Duration | 3 minutes and 10.53 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
Severity
Categorical
Imbalance 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 107.6 MiB |
| 2 | |
|---|---|
| 3 | |
| 4 | 178538 |
| 1 | 65051 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 3 |
| 3rd row | 2 |
| 4th row | 3 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 5671504 | |
| 3 | 1136467 | 16.1% |
| 4 | 178538 | 2.5% |
| 1 | 65051 | 0.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 5671504 | |
| 3 | 1136467 | 16.1% |
| 4 | 178538 | 2.5% |
| 1 | 65051 | 0.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 5671504 | |
| 3 | 1136467 | 16.1% |
| 4 | 178538 | 2.5% |
| 1 | 65051 | 0.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7051560 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 5671504 | |
| 3 | 1136467 | 16.1% |
| 4 | 178538 | 2.5% |
| 1 | 65051 | 0.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7051560 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 5671504 | |
| 3 | 1136467 | 16.1% |
| 4 | 178538 | 2.5% |
| 1 | 65051 | 0.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7051560 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 5671504 | |
| 3 | 1136467 | 16.1% |
| 4 | 178538 | 2.5% |
| 1 | 65051 | 0.9% |
Distance(mi)
Real number (ℝ)
Zeros 
| Distinct | 21687 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.56854528 |
| Minimum | 0 |
|---|---|
| Maximum | 441.75 |
| Zeros | 2959002 |
| Zeros (%) | 42.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 107.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.037 |
| Q3 | 0.478 |
| 95-th percentile | 2.697 |
| Maximum | 441.75 |
| Range | 441.75 |
| Interquartile range (IQR) | 0.478 |
Descriptive statistics
| Standard deviation | 1.7641632 |
|---|---|
| Coefficient of variation (CV) | 3.1029423 |
| Kurtosis | 1583.1938 |
| Mean | 0.56854528 |
| Median Absolute Deviation (MAD) | 0.037 |
| Skewness | 19.843757 |
| Sum | 4009131.2 |
| Variance | 3.1122718 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2959002 | |
| 0.01 | 212576 | 3.0% |
| 0.008 | 13880 | 0.2% |
| 0.009 | 13182 | 0.2% |
| 0.007 | 11733 | 0.2% |
| 0.009999999776 | 11083 | 0.2% |
| 0.011 | 11011 | 0.2% |
| 0.03 | 10801 | 0.2% |
| 0.024 | 10372 | 0.1% |
| 0.028 | 10332 | 0.1% |
| Other values (21677) | 3787588 |
| Value | Count | Frequency (%) |
| 0 | 2959002 | |
| 0.001 | 4680 | 0.1% |
| 0.002 | 2694 | < 0.1% |
| 0.003 | 3934 | 0.1% |
| 0.004 | 5931 | 0.1% |
| 0.005 | 7752 | 0.1% |
| 0.006 | 9600 | 0.1% |
| 0.007 | 11733 | 0.2% |
| 0.008 | 13880 | 0.2% |
| 0.009 | 13182 | 0.2% |
| Value | Count | Frequency (%) |
| 441.75 | 1 | |
| 336.5700073 | 1 | |
| 254.3999939 | 1 | |
| 251.2200012 | 1 | |
| 242.3399963 | 1 | |
| 224.5899963 | 1 | |
| 210.0800018 | 1 | |
| 194.7299957 | 1 | |
| 193.4799957 | 1 | |
| 183.1199951 | 1 |
Street
Text
| Distinct | 320207 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 107.6 MiB |
Length
| Max length | 59 |
|---|---|
| Median length | 47 |
| Mean length | 11.063362 |
| Min length | 1 |
Unique
| Unique | 124428 ? |
|---|---|
| Unique (%) | 1.8% |
Sample
| 1st row | State Route 32 |
|---|---|
| 2nd row | I-75 S |
| 3rd row | Miamisburg Centerville Rd |
| 4th row | Westerville Rd |
| 5th row | N Woodward Ave |
| Value | Count | Frequency (%) |
| n | 1092408 | 6.2% |
| s | 1088072 | 6.2% |
| rd | 1056801 | 6.0% |
| w | 859562 | 4.9% |
| e | 849902 | 4.9% |
| st | 629910 | 3.6% |
| ave | 590604 | 3.4% |
| blvd | 314610 | 1.8% |
| dr | 301258 | 1.7% |
| fwy | 286513 | 1.6% |
| Other values (71822) | 10436013 |
Most occurring characters
| Value | Count | Frequency (%) |
| 12059741 | 15.5% | |
| e | 4346299 | 5.6% |
| a | 3471039 | 4.4% |
| r | 2955808 | 3.8% |
| t | 2936495 | 3.8% |
| S | 2722829 | 3.5% |
| o | 2720548 | 3.5% |
| n | 2713466 | 3.5% |
| d | 2540155 | 3.3% |
| l | 2520382 | 3.2% |
| Other values (70) | 39027199 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 78013961 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 12059741 | 15.5% | |
| e | 4346299 | 5.6% |
| a | 3471039 | 4.4% |
| r | 2955808 | 3.8% |
| t | 2936495 | 3.8% |
| S | 2722829 | 3.5% |
| o | 2720548 | 3.5% |
| n | 2713466 | 3.5% |
| d | 2540155 | 3.3% |
| l | 2520382 | 3.2% |
| Other values (70) | 39027199 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 78013961 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 12059741 | 15.5% | |
| e | 4346299 | 5.6% |
| a | 3471039 | 4.4% |
| r | 2955808 | 3.8% |
| t | 2936495 | 3.8% |
| S | 2722829 | 3.5% |
| o | 2720548 | 3.5% |
| n | 2713466 | 3.5% |
| d | 2540155 | 3.3% |
| l | 2520382 | 3.2% |
| Other values (70) | 39027199 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 78013961 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 12059741 | 15.5% | |
| e | 4346299 | 5.6% |
| a | 3471039 | 4.4% |
| r | 2955808 | 3.8% |
| t | 2936495 | 3.8% |
| S | 2722829 | 3.5% |
| o | 2720548 | 3.5% |
| n | 2713466 | 3.5% |
| d | 2540155 | 3.3% |
| l | 2520382 | 3.2% |
| Other values (70) | 39027199 |
Zipcode
Text
| Distinct | 774620 |
|---|---|
| Distinct (%) | 11.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 107.6 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 5 |
| Mean length | 6.4828095 |
| Min length | 5 |
Unique
| Unique | 426008 ? |
|---|---|
| Unique (%) | 6.0% |
Sample
| 1st row | 45176 |
|---|---|
| 2nd row | 45417 |
| 3rd row | 45459 |
| 4th row | 43081 |
| 5th row | 45417-2476 |
| Value | Count | Frequency (%) |
| 91761 | 10683 | 0.2% |
| 91706 | 8692 | 0.1% |
| 92507 | 8177 | 0.1% |
| 92407 | 8071 | 0.1% |
| 33186 | 7929 | 0.1% |
| 32819 | 7269 | 0.1% |
| 33169 | 6658 | 0.1% |
| 75243 | 6570 | 0.1% |
| 92324 | 6322 | 0.1% |
| 90805 | 6244 | 0.1% |
| Other values (774610) | 6974945 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5737493 | |
| 2 | 5601412 | |
| 3 | 5244330 | |
| 1 | 5204712 | |
| 9 | 4041057 | |
| 7 | 3954685 | |
| 5 | 3858349 | |
| 4 | 3801049 | |
| 6 | 3151443 | |
| 8 | 3022532 | |
| Other values (3) | 2096858 | 4.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 45713920 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 5737493 | |
| 2 | 5601412 | |
| 3 | 5244330 | |
| 1 | 5204712 | |
| 9 | 4041057 | |
| 7 | 3954685 | |
| 5 | 3858349 | |
| 4 | 3801049 | |
| 6 | 3151443 | |
| 8 | 3022532 | |
| Other values (3) | 2096858 | 4.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 45713920 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 5737493 | |
| 2 | 5601412 | |
| 3 | 5244330 | |
| 1 | 5204712 | |
| 9 | 4041057 | |
| 7 | 3954685 | |
| 5 | 3858349 | |
| 4 | 3801049 | |
| 6 | 3151443 | |
| 8 | 3022532 | |
| Other values (3) | 2096858 | 4.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 45713920 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 5737493 | |
| 2 | 5601412 | |
| 3 | 5244330 | |
| 1 | 5204712 | |
| 9 | 4041057 | |
| 7 | 3954685 | |
| 5 | 3858349 | |
| 4 | 3801049 | |
| 6 | 3151443 | |
| 8 | 3022532 | |
| Other values (3) | 2096858 | 4.6% |
Temperature(F)
Real number (ℝ)
| Distinct | 829 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 61.869611 |
| Minimum | -45 |
|---|---|
| Maximum | 196 |
| Zeros | 2651 |
| Zeros (%) | < 0.1% |
| Negative | 18053 |
| Negative (%) | 0.3% |
| Memory size | 107.6 MiB |
Quantile statistics
| Minimum | -45 |
|---|---|
| 5-th percentile | 28 |
| Q1 | 49 |
| median | 64 |
| Q3 | 76 |
| 95-th percentile | 89 |
| Maximum | 196 |
| Range | 241 |
| Interquartile range (IQR) | 27 |
Descriptive statistics
| Standard deviation | 19.042054 |
|---|---|
| Coefficient of variation (CV) | 0.30777717 |
| Kurtosis | -0.014583106 |
| Mean | 61.869611 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | -0.52138711 |
| Sum | 4.3627728 × 108 |
| Variance | 362.59983 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 73 | 162688 | 2.3% |
| 77 | 160720 | 2.3% |
| 72 | 152716 | 2.2% |
| 68 | 151851 | 2.2% |
| 75 | 150957 | 2.1% |
| 70 | 147290 | 2.1% |
| 63 | 141625 | 2.0% |
| 79 | 141137 | 2.0% |
| 64 | 139891 | 2.0% |
| 66 | 136900 | 1.9% |
| Other values (819) | 5565785 |
| Value | Count | Frequency (%) |
| -45 | 1 | < 0.1% |
| -38 | 3 | < 0.1% |
| -36 | 2 | < 0.1% |
| -35 | 9 | |
| -33 | 1 | < 0.1% |
| -30 | 1 | < 0.1% |
| -29 | 8 | |
| -28 | 5 | |
| -27.9 | 12 | |
| -27.4 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 196 | 5 | |
| 189 | 1 | < 0.1% |
| 174 | 2 | < 0.1% |
| 172 | 2 | < 0.1% |
| 170.6 | 1 | < 0.1% |
| 168.8 | 1 | < 0.1% |
| 167 | 1 | < 0.1% |
| 162 | 2 | < 0.1% |
| 161.6 | 1 | < 0.1% |
| 143.6 | 1 | < 0.1% |
Humidity(%)
Real number (ℝ)
| Distinct | 100 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 64.415366 |
| Minimum | 1 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 107.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 48 |
| median | 67 |
| Q3 | 84 |
| 95-th percentile | 96 |
| Maximum | 100 |
| Range | 99 |
| Interquartile range (IQR) | 36 |
Descriptive statistics
| Standard deviation | 22.757178 |
|---|---|
| Coefficient of variation (CV) | 0.35328803 |
| Kurtosis | -0.72760491 |
| Mean | 64.415366 |
| Median Absolute Deviation (MAD) | 18 |
| Skewness | -0.38008968 |
| Sum | 4.5422882 × 108 |
| Variance | 517.88913 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 93 | 264622 | 3.8% |
| 100 | 246092 | 3.5% |
| 87 | 156275 | 2.2% |
| 90 | 154061 | 2.2% |
| 89 | 128993 | 1.8% |
| 96 | 120746 | 1.7% |
| 81 | 117405 | 1.7% |
| 84 | 117210 | 1.7% |
| 82 | 114896 | 1.6% |
| 86 | 112259 | 1.6% |
| Other values (90) | 5519001 |
| Value | Count | Frequency (%) |
| 1 | 45 | < 0.1% |
| 2 | 189 | < 0.1% |
| 3 | 656 | < 0.1% |
| 4 | 2070 | < 0.1% |
| 5 | 3970 | 0.1% |
| 6 | 5781 | |
| 7 | 7731 | |
| 8 | 9169 | |
| 9 | 10550 | |
| 10 | 12848 |
| Value | Count | Frequency (%) |
| 100 | 246092 | |
| 99 | 12864 | 0.2% |
| 98 | 6129 | 0.1% |
| 97 | 79382 | 1.1% |
| 96 | 120746 | |
| 95 | 8565 | 0.1% |
| 94 | 104894 | 1.5% |
| 93 | 264622 | |
| 92 | 60688 | 0.9% |
| 91 | 34646 | 0.5% |
Pressure(in)
Real number (ℝ)
| Distinct | 1126 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.514437 |
| Minimum | 0 |
|---|---|
| Maximum | 58.63 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 107.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 27.85 |
| Q1 | 29.34 |
| median | 29.84 |
| Q3 | 30.02 |
| 95-th percentile | 30.24 |
| Maximum | 58.63 |
| Range | 58.63 |
| Interquartile range (IQR) | 0.68 |
Descriptive statistics
| Standard deviation | 1.0148514 |
|---|---|
| Coefficient of variation (CV) | 0.034384914 |
| Kurtosis | 19.955612 |
| Mean | 29.514437 |
| Median Absolute Deviation (MAD) | 0.25 |
| Skewness | -3.5478432 |
| Sum | 2.0812282 × 108 |
| Variance | 1.0299233 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 29.96 | 111934 | 1.6% |
| 29.99 | 109652 | 1.6% |
| 29.94 | 108617 | 1.5% |
| 30.01 | 106437 | 1.5% |
| 29.97 | 102676 | 1.5% |
| 29.91 | 101754 | 1.4% |
| 29.95 | 100739 | 1.4% |
| 30.04 | 100576 | 1.4% |
| 30.03 | 99319 | 1.4% |
| 30 | 99191 | 1.4% |
| Other values (1116) | 6010665 |
| Value | Count | Frequency (%) |
| 0 | 2 | < 0.1% |
| 0.02 | 1 | < 0.1% |
| 0.29 | 2 | < 0.1% |
| 0.39 | 1 | < 0.1% |
| 2.99 | 5 | |
| 3 | 2 | < 0.1% |
| 3.01 | 1 | < 0.1% |
| 3.04 | 4 | |
| 9.9 | 2 | < 0.1% |
| 16.71 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 58.63 | 7 | |
| 58.39 | 2 | < 0.1% |
| 58.32 | 1 | < 0.1% |
| 58.13 | 1 | < 0.1% |
| 58.1 | 4 | |
| 58.04 | 3 | |
| 57.74 | 1 | < 0.1% |
| 57.54 | 2 | < 0.1% |
| 56.54 | 2 | < 0.1% |
| 56.31 | 1 | < 0.1% |
Visibility(mi)
Real number (ℝ)
| Distinct | 81 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.1070711 |
| Minimum | 0 |
|---|---|
| Maximum | 140 |
| Zeros | 7236 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 107.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.5 |
| Q1 | 10 |
| median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 140 |
| Range | 140 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.6422642 |
|---|---|
| Coefficient of variation (CV) | 0.29013326 |
| Kurtosis | 80.462982 |
| Mean | 9.1070711 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.1147471 |
| Sum | 64219058 |
| Variance | 6.98156 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 5701259 | |
| 7 | 194895 | 2.8% |
| 9 | 172317 | 2.4% |
| 8 | 136720 | 1.9% |
| 5 | 130384 | 1.8% |
| 6 | 116029 | 1.6% |
| 2 | 115544 | 1.6% |
| 4 | 109570 | 1.6% |
| 3 | 108489 | 1.5% |
| 1 | 98051 | 1.4% |
| Other values (71) | 168302 | 2.4% |
| Value | Count | Frequency (%) |
| 0 | 7236 | 0.1% |
| 0.06 | 316 | < 0.1% |
| 0.1 | 870 | < 0.1% |
| 0.12 | 1749 | < 0.1% |
| 0.19 | 41 | < 0.1% |
| 0.2 | 7184 | 0.1% |
| 0.25 | 26547 | |
| 0.31 | 4 | < 0.1% |
| 0.38 | 328 | < 0.1% |
| 0.4 | 52 | < 0.1% |
| Value | Count | Frequency (%) |
| 140 | 1 | < 0.1% |
| 111 | 3 | < 0.1% |
| 105 | 1 | < 0.1% |
| 101 | 1 | < 0.1% |
| 100 | 47 | < 0.1% |
| 98 | 1 | < 0.1% |
| 90 | 13 | < 0.1% |
| 80 | 295 | |
| 78 | 1 | < 0.1% |
| 76 | 3 | < 0.1% |
Wind_Direction
Categorical
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 107.6 MiB |
| CALM | |
|---|---|
| S | 413902 |
| SSW | 379701 |
| W | 378400 |
| WNW | 373374 |
| Other values (18) |
Length
| Max length | 8 |
|---|---|
| Median length | 5 |
| Mean length | 2.7674176 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SW |
|---|---|
| 2nd row | SW |
| 3rd row | SW |
| 4th row | SSW |
| 5th row | WSW |
Common Values
| Value | Count | Frequency (%) |
| CALM | 942803 | 13.4% |
| S | 413902 | 5.9% |
| SSW | 379701 | 5.4% |
| W | 378400 | 5.4% |
| WNW | 373374 | 5.3% |
| NW | 364394 | 5.2% |
| SW | 359826 | 5.1% |
| WSW | 348591 | 4.9% |
| SSE | 344112 | 4.9% |
| NNW | 328354 | 4.7% |
| Other values (13) | 2818103 |
Length
| Value | Count | Frequency (%) |
| calm | 942803 | 13.4% |
| s | 413902 | 5.9% |
| ssw | 379701 | 5.4% |
| w | 378400 | 5.4% |
| wnw | 373374 | 5.3% |
| nw | 364394 | 5.2% |
| sw | 359826 | 5.1% |
| wsw | 348591 | 4.9% |
| sse | 344112 | 4.9% |
| nnw | 328354 | 4.7% |
| Other values (13) | 2818103 |
Most occurring characters
| Value | Count | Frequency (%) |
| W | 3416992 | |
| S | 3301407 | |
| N | 2833882 | |
| E | 2558297 | |
| A | 1189944 | 6.1% |
| M | 942803 | 4.8% |
| L | 942803 | 4.8% |
| C | 942803 | 4.8% |
| t | 564925 | 2.9% |
| V | 359219 | 1.8% |
| Other values (11) | 2461536 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 19514611 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| W | 3416992 | |
| S | 3301407 | |
| N | 2833882 | |
| E | 2558297 | |
| A | 1189944 | 6.1% |
| M | 942803 | 4.8% |
| L | 942803 | 4.8% |
| C | 942803 | 4.8% |
| t | 564925 | 2.9% |
| V | 359219 | 1.8% |
| Other values (11) | 2461536 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 19514611 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| W | 3416992 | |
| S | 3301407 | |
| N | 2833882 | |
| E | 2558297 | |
| A | 1189944 | 6.1% |
| M | 942803 | 4.8% |
| L | 942803 | 4.8% |
| C | 942803 | 4.8% |
| t | 564925 | 2.9% |
| V | 359219 | 1.8% |
| Other values (11) | 2461536 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 19514611 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| W | 3416992 | |
| S | 3301407 | |
| N | 2833882 | |
| E | 2558297 | |
| A | 1189944 | 6.1% |
| M | 942803 | 4.8% |
| L | 942803 | 4.8% |
| C | 942803 | 4.8% |
| t | 564925 | 2.9% |
| V | 359219 | 1.8% |
| Other values (11) | 2461536 |
Wind_Speed(mph)
Real number (ℝ)
Zeros 
| Distinct | 179 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.6911295 |
| Minimum | 0 |
|---|---|
| Maximum | 1087 |
| Zeros | 942813 |
| Zeros (%) | 13.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 107.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 4.6 |
| median | 7 |
| Q3 | 10.4 |
| 95-th percentile | 17 |
| Maximum | 1087 |
| Range | 1087 |
| Interquartile range (IQR) | 5.8 |
Descriptive statistics
| Standard deviation | 5.4122238 |
|---|---|
| Coefficient of variation (CV) | 0.70369688 |
| Kurtosis | 1088.9651 |
| Mean | 7.6911295 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 7.9491258 |
| Sum | 54234461 |
| Variance | 29.292167 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 942813 | 13.4% |
| 5 | 526299 | 7.5% |
| 6 | 508834 | 7.2% |
| 3 | 506264 | 7.2% |
| 7 | 473560 | 6.7% |
| 8 | 426369 | 6.0% |
| 9 | 383468 | 5.4% |
| 10 | 319588 | 4.5% |
| 12 | 276284 | 3.9% |
| 4.6 | 214994 | 3.0% |
| Other values (169) | 2473087 |
| Value | Count | Frequency (%) |
| 0 | 942813 | |
| 1 | 166 | < 0.1% |
| 1.2 | 440 | < 0.1% |
| 2 | 427 | < 0.1% |
| 2.3 | 890 | < 0.1% |
| 3 | 506264 | |
| 3.5 | 201212 | 2.9% |
| 4.6 | 214994 | 3.0% |
| 5 | 526299 | |
| 5.8 | 213280 | 3.0% |
| Value | Count | Frequency (%) |
| 1087 | 1 | < 0.1% |
| 984 | 1 | < 0.1% |
| 822.8 | 7 | |
| 812 | 1 | < 0.1% |
| 703.1 | 2 | < 0.1% |
| 580 | 2 | < 0.1% |
| 471.8 | 1 | < 0.1% |
| 328 | 1 | < 0.1% |
| 255 | 1 | < 0.1% |
| 254.3 | 2 | < 0.1% |
| Distinct | 140 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 107.6 MiB |
Length
| Max length | 35 |
|---|---|
| Median length | 30 |
| Mean length | 7.6752019 |
| Min length | 3 |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Overcast |
|---|---|
| 2nd row | Mostly Cloudy |
| 3rd row | Mostly Cloudy |
| 4th row | Light Rain |
| 5th row | Overcast |
| Value | Count | Frequency (%) |
| fair | 2536998 | |
| cloudy | 2472945 | |
| mostly | 983438 | 10.0% |
| partly | 672146 | 6.9% |
| clear | 615352 | 6.3% |
| light | 519905 | 5.3% |
| rain | 484808 | 4.9% |
| overcast | 321868 | 3.3% |
| scattered | 176183 | 1.8% |
| clouds | 176183 | 1.8% |
| Other values (48) | 840646 | 8.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 4957471 | 9.2% |
| a | 4945655 | 9.1% |
| r | 4471321 | 8.3% |
| y | 4315734 | 8.0% |
| o | 3950113 | 7.3% |
| i | 3805617 | 7.0% |
| C | 3264496 | 6.0% |
| d | 2999461 | 5.5% |
| t | 2966355 | 5.5% |
| 2748912 | 5.1% | |
| Other values (36) | 15697012 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 54122147 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 4957471 | 9.2% |
| a | 4945655 | 9.1% |
| r | 4471321 | 8.3% |
| y | 4315734 | 8.0% |
| o | 3950113 | 7.3% |
| i | 3805617 | 7.0% |
| C | 3264496 | 6.0% |
| d | 2999461 | 5.5% |
| t | 2966355 | 5.5% |
| 2748912 | 5.1% | |
| Other values (36) | 15697012 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 54122147 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 4957471 | 9.2% |
| a | 4945655 | 9.1% |
| r | 4471321 | 8.3% |
| y | 4315734 | 8.0% |
| o | 3950113 | 7.3% |
| i | 3805617 | 7.0% |
| C | 3264496 | 6.0% |
| d | 2999461 | 5.5% |
| t | 2966355 | 5.5% |
| 2748912 | 5.1% | |
| Other values (36) | 15697012 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 54122147 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 4957471 | 9.2% |
| a | 4945655 | 9.1% |
| r | 4471321 | 8.3% |
| y | 4315734 | 8.0% |
| o | 3950113 | 7.3% |
| i | 3805617 | 7.0% |
| C | 3264496 | 6.0% |
| d | 2999461 | 5.5% |
| t | 2966355 | 5.5% |
| 2748912 | 5.1% | |
| Other values (36) | 15697012 |
Amenity
Boolean
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 60.5 MiB |
| False | |
|---|---|
| True | 87859 |
| Value | Count | Frequency (%) |
| False | 6963701 | |
| True | 87859 | 1.2% |
| Value | Count | Frequency (%) |
| False | 6243875 | |
| True | 807685 | 11.5% |
Give_Way
Boolean
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 60.5 MiB |
| False | |
|---|---|
| True | 32705 |
| Value | Count | Frequency (%) |
| False | 7018855 | |
| True | 32705 | 0.5% |
Junction
Boolean
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 60.5 MiB |
| False | |
|---|---|
| True | 514454 |
| Value | Count | Frequency (%) |
| False | 6537106 | |
| True | 514454 | 7.3% |
No_Exit
Boolean
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 60.5 MiB |
| False | |
|---|---|
| True | 18113 |
| Value | Count | Frequency (%) |
| False | 7033447 | |
| True | 18113 | 0.3% |
Railway
Boolean
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 60.5 MiB |
| False | |
|---|---|
| True | 60566 |
| Value | Count | Frequency (%) |
| False | 6990994 | |
| True | 60566 | 0.9% |
Stop
Boolean
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 60.5 MiB |
| False | |
|---|---|
| True | 195390 |
| Value | Count | Frequency (%) |
| False | 6856170 | |
| True | 195390 | 2.8% |
Traffic_Calming
Boolean
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 60.5 MiB |
| False | |
|---|---|
| True | 6980 |
| Value | Count | Frequency (%) |
| False | 7044580 | |
| True | 6980 | 0.1% |
Traffic_Signal
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 60.5 MiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 6009292 | |
| True | 1042268 | 14.8% |
Civil_Twilight
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 107.6 MiB |
| Day | |
|---|---|
| Night |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.5119528 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Night |
|---|---|
| 2nd row | Day |
| 3rd row | Day |
| 4th row | Day |
| 5th row | Day |
Common Values
| Value | Count | Frequency (%) |
| Day | 5246527 | |
| Night | 1805033 | 25.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| day | 5246527 | |
| night | 1805033 | 25.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 5246527 | |
| a | 5246527 | |
| y | 5246527 | |
| N | 1805033 | 7.3% |
| i | 1805033 | 7.3% |
| g | 1805033 | 7.3% |
| h | 1805033 | 7.3% |
| t | 1805033 | 7.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 24764746 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| D | 5246527 | |
| a | 5246527 | |
| y | 5246527 | |
| N | 1805033 | 7.3% |
| i | 1805033 | 7.3% |
| g | 1805033 | 7.3% |
| h | 1805033 | 7.3% |
| t | 1805033 | 7.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 24764746 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| D | 5246527 | |
| a | 5246527 | |
| y | 5246527 | |
| N | 1805033 | 7.3% |
| i | 1805033 | 7.3% |
| g | 1805033 | 7.3% |
| h | 1805033 | 7.3% |
| t | 1805033 | 7.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 24764746 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| D | 5246527 | |
| a | 5246527 | |
| y | 5246527 | |
| N | 1805033 | 7.3% |
| i | 1805033 | 7.3% |
| g | 1805033 | 7.3% |
| h | 1805033 | 7.3% |
| t | 1805033 | 7.3% |
Duration_Seconds
Real number (ℝ)
Skewed 
| Distinct | 72892 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26947.592 |
| Minimum | 120 |
|---|---|
| Maximum | 1.6877634 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 107.6 MiB |
Quantile statistics
| Minimum | 120 |
|---|---|
| 5-th percentile | 1718 |
| Q1 | 2068 |
| median | 4502 |
| Q3 | 7539 |
| 95-th percentile | 21600 |
| Maximum | 1.6877634 × 108 |
| Range | 1.6877622 × 108 |
| Interquartile range (IQR) | 5471 |
Descriptive statistics
| Standard deviation | 816632.16 |
|---|---|
| Coefficient of variation (CV) | 30.304458 |
| Kurtosis | 3685.2728 |
| Mean | 26947.592 |
| Median Absolute Deviation (MAD) | 2707 |
| Skewness | 50.611689 |
| Sum | 1.9002256 × 1011 |
| Variance | 6.6688808 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 21600 | 301728 | 4.3% |
| 1800 | 101353 | 1.4% |
| 2700 | 61354 | 0.9% |
| 4500 | 58442 | 0.8% |
| 3600 | 55270 | 0.8% |
| 14400 | 50458 | 0.7% |
| 1786 | 46694 | 0.7% |
| 1785 | 46645 | 0.7% |
| 1787 | 45598 | 0.6% |
| 1784 | 45229 | 0.6% |
| Other values (72882) | 6238789 |
| Value | Count | Frequency (%) |
| 120 | 2 | < 0.1% |
| 150 | 3 | < 0.1% |
| 152 | 1 | < 0.1% |
| 180 | 16 | |
| 210 | 6 | < 0.1% |
| 221 | 1 | < 0.1% |
| 229 | 1 | < 0.1% |
| 240 | 12 | |
| 270 | 5 | < 0.1% |
| 271 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 168776340 | 2 | |
| 134184345 | 1 | < 0.1% |
| 134181332 | 3 | |
| 134179838 | 3 | |
| 134176830 | 2 | |
| 106135755 | 1 | < 0.1% |
| 100954757 | 1 | < 0.1% |
| 94755540 | 1 | < 0.1% |
| 94697995 | 1 | < 0.1% |
| 94697990 | 1 | < 0.1% |
Interactions
Correlations
| Amenity | Civil_Twilight | Crossing | Distance(mi) | Duration_Seconds | Give_Way | Humidity(%) | Junction | No_Exit | Pressure(in) | Railway | Severity | Stop | Temperature(F) | Traffic_Calming | Traffic_Signal | Visibility(mi) | Wind_Direction | Wind_Speed(mph) | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Amenity | 1.000 | 0.006 | 0.148 | 0.000 | 0.002 | 0.006 | 0.015 | 0.026 | 0.014 | 0.023 | 0.050 | 0.038 | 0.034 | 0.010 | 0.023 | 0.105 | 0.002 | 0.023 | 0.000 |
| Civil_Twilight | 0.006 | 1.000 | 0.039 | 0.003 | 0.007 | 0.005 | 0.245 | 0.015 | 0.004 | 0.035 | 0.000 | 0.058 | 0.001 | 0.280 | 0.000 | 0.045 | 0.015 | 0.183 | 0.001 |
| Crossing | 0.148 | 0.039 | 1.000 | 0.004 | 0.008 | 0.058 | 0.036 | 0.088 | 0.062 | 0.036 | 0.179 | 0.119 | 0.118 | 0.062 | 0.037 | 0.476 | 0.007 | 0.054 | 0.001 |
| Distance(mi) | 0.000 | 0.003 | 0.004 | 1.000 | 0.394 | 0.000 | -0.010 | 0.001 | 0.000 | -0.108 | 0.000 | 0.005 | 0.002 | -0.062 | 0.001 | 0.004 | -0.014 | 0.001 | -0.005 |
| Duration_Seconds | 0.002 | 0.007 | 0.008 | 0.394 | 1.000 | 0.001 | -0.011 | 0.009 | 0.001 | -0.112 | 0.001 | 0.009 | 0.004 | -0.033 | 0.000 | 0.008 | 0.005 | 0.005 | -0.038 |
| Give_Way | 0.006 | 0.005 | 0.058 | 0.000 | 0.001 | 1.000 | 0.004 | 0.009 | 0.006 | 0.007 | 0.003 | 0.008 | 0.030 | 0.005 | 0.003 | 0.072 | 0.007 | 0.010 | 0.000 |
| Humidity(%) | 0.015 | 0.245 | 0.036 | -0.010 | -0.011 | 0.004 | 1.000 | 0.009 | 0.009 | 0.043 | 0.006 | 0.028 | 0.026 | -0.331 | 0.005 | 0.022 | -0.464 | 0.084 | -0.199 |
| Junction | 0.026 | 0.015 | 0.088 | 0.001 | 0.009 | 0.009 | 0.009 | 1.000 | 0.004 | 0.027 | 0.009 | 0.051 | 0.036 | 0.027 | 0.005 | 0.104 | 0.004 | 0.029 | 0.000 |
| No_Exit | 0.014 | 0.004 | 0.062 | 0.000 | 0.001 | 0.006 | 0.009 | 0.004 | 1.000 | 0.007 | 0.004 | 0.012 | 0.026 | 0.009 | 0.013 | 0.030 | 0.007 | 0.006 | 0.000 |
| Pressure(in) | 0.023 | 0.035 | 0.036 | -0.108 | -0.112 | 0.007 | 0.043 | 0.027 | 0.007 | 1.000 | 0.017 | 0.042 | 0.003 | 0.021 | 0.005 | 0.035 | 0.078 | 0.077 | 0.000 |
| Railway | 0.050 | 0.000 | 0.179 | 0.000 | 0.001 | 0.003 | 0.006 | 0.009 | 0.004 | 0.017 | 1.000 | 0.014 | 0.007 | 0.010 | 0.006 | 0.059 | 0.003 | 0.007 | 0.000 |
| Severity | 0.038 | 0.058 | 0.119 | 0.005 | 0.009 | 0.008 | 0.028 | 0.051 | 0.012 | 0.042 | 0.014 | 1.000 | 0.058 | 0.038 | 0.005 | 0.119 | 0.012 | 0.097 | 0.001 |
| Stop | 0.034 | 0.001 | 0.118 | 0.002 | 0.004 | 0.030 | 0.026 | 0.036 | 0.026 | 0.003 | 0.007 | 0.058 | 1.000 | 0.016 | 0.027 | 0.048 | 0.001 | 0.009 | 0.000 |
| Temperature(F) | 0.010 | 0.280 | 0.062 | -0.062 | -0.033 | 0.005 | -0.331 | 0.027 | 0.009 | 0.021 | 0.010 | 0.038 | 0.016 | 1.000 | 0.006 | 0.047 | 0.228 | 0.083 | 0.088 |
| Traffic_Calming | 0.023 | 0.000 | 0.037 | 0.001 | 0.000 | 0.003 | 0.005 | 0.005 | 0.013 | 0.005 | 0.006 | 0.005 | 0.027 | 0.006 | 1.000 | 0.011 | 0.002 | 0.006 | 0.000 |
| Traffic_Signal | 0.105 | 0.045 | 0.476 | 0.004 | 0.008 | 0.072 | 0.022 | 0.104 | 0.030 | 0.035 | 0.059 | 0.119 | 0.048 | 0.047 | 0.011 | 1.000 | 0.002 | 0.075 | 0.002 |
| Visibility(mi) | 0.002 | 0.015 | 0.007 | -0.014 | 0.005 | 0.007 | -0.464 | 0.004 | 0.007 | 0.078 | 0.003 | 0.012 | 0.001 | 0.228 | 0.002 | 0.002 | 1.000 | 0.010 | 0.055 |
| Wind_Direction | 0.023 | 0.183 | 0.054 | 0.001 | 0.005 | 0.010 | 0.084 | 0.029 | 0.006 | 0.077 | 0.007 | 0.097 | 0.009 | 0.083 | 0.006 | 0.075 | 0.010 | 1.000 | 0.002 |
| Wind_Speed(mph) | 0.000 | 0.001 | 0.001 | -0.005 | -0.038 | 0.000 | -0.199 | 0.000 | 0.000 | 0.000 | 0.000 | 0.001 | 0.000 | 0.088 | 0.000 | 0.002 | 0.055 | 0.002 | 1.000 |
Missing values
Sample
| Severity | Distance(mi) | Street | Zipcode | Temperature(F) | Humidity(%) | Pressure(in) | Visibility(mi) | Wind_Direction | Wind_Speed(mph) | Weather_Condition | Amenity | Crossing | Give_Way | Junction | No_Exit | Railway | Stop | Traffic_Calming | Traffic_Signal | Civil_Twilight | Duration_Seconds | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 2 | 0.01 | State Route 32 | 45176 | 36.0 | 100.0 | 29.67 | 10.0 | SW | 3.5 | Overcast | False | False | False | False | False | False | False | False | True | Night | 1800.0 |
| 3 | 3 | 0.01 | I-75 S | 45417 | 35.1 | 96.0 | 29.64 | 9.0 | SW | 4.6 | Mostly Cloudy | False | False | False | False | False | False | False | False | False | Day | 1800.0 |
| 4 | 2 | 0.01 | Miamisburg Centerville Rd | 45459 | 36.0 | 89.0 | 29.65 | 6.0 | SW | 3.5 | Mostly Cloudy | False | False | False | False | False | False | False | False | True | Day | 1800.0 |
| 5 | 3 | 0.01 | Westerville Rd | 43081 | 37.9 | 97.0 | 29.63 | 7.0 | SSW | 3.5 | Light Rain | False | False | False | False | False | False | False | False | False | Day | 1800.0 |
| 6 | 2 | 0.00 | N Woodward Ave | 45417-2476 | 34.0 | 100.0 | 29.66 | 7.0 | WSW | 3.5 | Overcast | False | False | False | False | False | False | False | False | False | Day | 1800.0 |
| 7 | 3 | 0.01 | N Main St | 45405 | 34.0 | 100.0 | 29.66 | 7.0 | WSW | 3.5 | Overcast | False | False | False | False | False | False | False | False | False | Day | 1800.0 |
| 8 | 2 | 0.00 | Notre Dame Ave | 45404-1923 | 33.3 | 99.0 | 29.67 | 5.0 | SW | 1.2 | Mostly Cloudy | False | False | False | False | False | False | False | False | False | Day | 1800.0 |
| 9 | 3 | 0.01 | Westerville Rd | 43081 | 37.4 | 100.0 | 29.62 | 3.0 | SSW | 4.6 | Light Rain | False | False | False | False | False | False | False | False | False | Day | 1800.0 |
| 10 | 3 | 0.01 | Outerbelt S | 43228 | 35.6 | 93.0 | 29.64 | 5.0 | WNW | 5.8 | Rain | False | True | False | True | False | False | False | False | False | Day | 1800.0 |
| 11 | 3 | 0.01 | I-70 E | 43068 | 37.4 | 100.0 | 29.62 | 3.0 | SSW | 4.6 | Light Rain | False | False | False | False | False | False | False | False | False | Day | 1800.0 |
| Severity | Distance(mi) | Street | Zipcode | Temperature(F) | Humidity(%) | Pressure(in) | Visibility(mi) | Wind_Direction | Wind_Speed(mph) | Weather_Condition | Amenity | Crossing | Give_Way | Junction | No_Exit | Railway | Stop | Traffic_Calming | Traffic_Signal | Civil_Twilight | Duration_Seconds | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7728384 | 2 | 0.390 | I-10 E | 91706 | 78.0 | 52.0 | 29.69 | 10.0 | VAR | 6.0 | Fair | False | False | False | False | False | False | False | False | False | Day | 1723.0 |
| 7728385 | 2 | 0.000 | CA-60 E | 92555 | 88.0 | 32.0 | 28.20 | 10.0 | WNW | 10.0 | Fair | False | False | False | False | False | False | False | False | False | Day | 1703.0 |
| 7728386 | 2 | 0.189 | El Camino Real N | 93003 | 73.0 | 68.0 | 29.76 | 10.0 | W | 9.0 | Fair | False | False | False | True | False | False | False | False | False | Day | 1703.0 |
| 7728387 | 2 | 0.443 | Santa Ana Fwy S | 92780 | 75.0 | 60.0 | 29.74 | 10.0 | SSW | 9.0 | Fair | False | False | False | False | False | False | False | False | False | Day | 1711.0 |
| 7728388 | 2 | 0.000 | Golden State Fwy N | 91331 | 81.0 | 48.0 | 28.78 | 10.0 | ESE | 6.0 | Fair | False | False | False | False | False | False | False | False | False | Day | 1711.0 |
| 7728389 | 2 | 0.543 | Pomona Fwy E | 92501 | 86.0 | 40.0 | 28.92 | 10.0 | W | 13.0 | Fair | False | False | False | False | False | False | False | False | False | Day | 1716.0 |
| 7728390 | 2 | 0.338 | I-8 W | 92108 | 70.0 | 73.0 | 29.39 | 10.0 | SW | 6.0 | Fair | False | False | False | False | False | False | False | False | False | Day | 1613.0 |
| 7728391 | 2 | 0.561 | Garden Grove Fwy | 92866 | 73.0 | 64.0 | 29.74 | 10.0 | SSW | 10.0 | Partly Cloudy | False | False | False | True | False | False | False | False | False | Day | 1708.0 |
| 7728392 | 2 | 0.772 | San Diego Fwy S | 90230 | 71.0 | 81.0 | 29.62 | 10.0 | SW | 8.0 | Fair | False | False | False | False | False | False | False | False | False | Day | 1761.0 |
| 7728393 | 2 | 0.537 | CA-210 W | 92346 | 79.0 | 47.0 | 28.63 | 7.0 | SW | 7.0 | Fair | False | False | False | False | False | False | False | False | False | Day | 1765.0 |
Duplicate rows
Most frequently occurring
| Severity | Distance(mi) | Street | Zipcode | Temperature(F) | Humidity(%) | Pressure(in) | Visibility(mi) | Wind_Direction | Wind_Speed(mph) | Weather_Condition | Amenity | Crossing | Give_Way | Junction | No_Exit | Railway | Stop | Traffic_Calming | Traffic_Signal | Civil_Twilight | Duration_Seconds | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 66851 | 2 | 0.229 | Lee Hwy | 22031-2318 | 46.6 | 68.0 | 30.36 | 10.0 | WSW | 5.8 | Clear | False | True | False | False | False | False | False | False | False | Day | 3389400.0 | 28 |
| 12943 | 2 | 0.000 | E Main St | 47327 | 21.7 | 89.0 | 30.17 | 5.0 | SW | 6.9 | Clear | False | False | False | False | False | False | False | False | True | Day | 1751.0 | 13 |
| 10831 | 2 | 0.000 | W Ridge Rd | 14559-1029 | 42.0 | 89.0 | 28.98 | 10.0 | NE | 5.0 | Cloudy | False | False | False | False | False | False | False | False | False | Night | 3600.0 | 12 |
| 140493 | 4 | 6.625 | E Historic Columbia River Hwy | 97019 | 69.0 | 63.0 | 30.01 | 10.0 | VAR | 3.0 | Fair | False | False | False | False | False | False | False | False | False | Day | 417709.0 | 12 |
| 121516 | 2 | 3.189 | I-84 E | 97058 | 25.0 | 80.0 | 29.62 | 2.0 | SE | 5.0 | Light Snow | False | False | False | False | False | False | False | False | False | Night | 28089.0 | 11 |
| 126843 | 2 | 7.424 | I-84 E | 97058 | 25.0 | 80.0 | 29.62 | 2.0 | SE | 5.0 | Light Snow | False | False | False | False | False | False | False | False | False | Night | 28089.0 | 11 |
| 129218 | 3 | 0.000 | Augusta Rd | 29073 | 75.0 | 100.0 | 29.74 | 1.0 | SE | 13.8 | Rain | False | False | False | False | False | False | False | False | False | Day | 1661.0 | 11 |
| 130737 | 3 | 0.000 | I-66 E | 22030 | 61.0 | 83.0 | 30.22 | 10.0 | SE | 9.2 | Mostly Cloudy | False | False | False | False | False | False | False | False | False | Day | 1737.0 | 11 |
| 131293 | 3 | 0.000 | I-95 N | 33179 | 78.0 | 100.0 | 29.91 | 10.0 | S | 5.0 | Partly Cloudy | False | False | False | False | False | False | False | False | False | Day | 2635.0 | 11 |
| 140482 | 4 | 6.625 | E Historic Columbia River Hwy | 97019 | 55.0 | 83.0 | 29.95 | 10.0 | E | 5.0 | Fair | False | False | False | False | False | False | False | False | False | Day | 604546.0 | 11 |